Overview

There have been concerns about gender pay equality in university settings. As a result, the Arizona Board of Regents has hired you to create a reporting system so that it can monitor the problem.

You need to build a system to automate the process of generating new reports when new data becomes available.

Packages

You will likely need to install the gender and genderdata packages from GitHub directly:

install.packages("remotes") # if necessary
remotes::install_github("lmullen/gender")
remotes::install_github("lmullen/genderdata")

Be sure to never include install commands in an RMD doc unless you include the chunk argument eval=F because it will create errors while knitting.

If you are getting errors while installing genderdata you might need to download the tarball (zipped package) from the link and install it using the local (instead of CRAN or GitHub option):

library( dplyr )
library( pander )
library( knitr )
library( gender )

You will create helper functions to clean and process data using instructions below. These will all be stored in a “utilities” file called utils.R and loaded into your report template using the source command:

source( "utils.R" )

Source commands typically go in the same chunk as load package commands.

Step 1: Data

We will be using the ASU salaries database distributed by the The State Press, and Arizona newspaper:

https://www.statepress.com/article/2017/04/spinvestigative-salary-database

Since ASU is a public university salary data is in the public domain, though the university doesn’t release it directly to the public. The State Press likely does a Freedom of Information request each year, cleans the data, and adds it to their online database of salaries (a google spreadsheet with several tabs):

https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/edit#gid=1335284952

We can use information embedded in this web link to create a convenient import command in R:

# WE NEED THE FORMAT: 
# https://docs.google.com/spreadsheets/d/<KEY>/export?gid=<GID>&format=csv
#
# where <KEY> and <GID> can be obtained from the base URL:
# https://docs.google.com/spreadsheets/d/<KEY>/edit#gid=<GID>

URL <- 'https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/export?gid=1335284952&format=csv'
d <- read.csv( URL )
head( d ) %>% pander()
Table continues below
Calendar.Year Full.Name Job.Description
2020 ABBASI, Mohammad Research/Lab Assistant
2020 ARQUIZA, Jose Maria Reynaldo Apollo Lecturer
2020 Aaberg, Kelsea Student Support Specialist
2020 Abadjivor, Enyah Project Manager
2020 Abayesu, Precious Management Intern
2020 Abbas, James Assoc Professor
Department.Description Salary FTE
Sch Biological & Hlth Sys Engr $35,090.00 100
Sch Biological & Hlth Sys Engr $71,400.00 100
Admission Services $36,000.00 100
CASGE Tempe $64,000.00 100
Health & Clinical Partnerships $20,800.00 50
Sch Biological & Hlth Sys Engr $107,195.00 100

Step 2: Parse First Name

You need to write a name parsing function that will take a Full.Name as the argument and return only the first name.

Note that the Full.Name variable has the format: LAST_NAME, FIRST_NAME MIDDLE_NAME

top.25 <- head( d$Full.Name,25 )
first.25 <- get_first_name( name=top.25 )

data.frame( top.25, first.25 ) %>% pander()
top.25 first.25
ABBASI, Mohammad Mohammad
ARQUIZA, Jose Maria Reynaldo Apollo Jose
Aaberg, Kelsea Kelsea
Abadjivor, Enyah Enyah
Abayesu, Precious Precious
Abbas, James James
Abbaszadegan, Morteza Morteza
Abbe, Scott Scott
Abbl, Norma Norma
Abbott, Joshua Joshua
Abbott, Joshua Joshua
Abdollahi, Amir Amir
Abdou, Olgeanna Olgeanna
Abdurhman, Abdurazak Abdurazak
Abel, John John
Abele, Kelsey Kelsey
Aberle, James James
Abhyankar, Aditya Aditya
Abi Karam, Karam Karam
AbiNader, Millan Millan
Aboalam, Safaa Safaa
Abraha, Naomi Naomi
Abramchuk, Mykola Mykola
Abrams, Cristen Cristen
Abrams, Kristen Kristen

Step 3: Code Gender

The database does not provide the gender of the employees, but that’s alright because we can code these ourselves once we have first names isolated.

The gender package allows us to query a database of US birth certificates to see the most likely gender of someone with a specific first name.

library( gender )

# need to save first names for the merge 
d$first.name <- get_first_name( name=d$Full.Name )

# create a list of unique first names in the data 
unique.first.names <- unique( d$first.name )

# get gender data from US Social Security Admin 
gen <- gender( unique.first.names )
head( gen ) %>% pander()
name proportion_male proportion_female gender year_min year_max
Aaron 0.9918 0.0082 male 1932 2012
Abba 1 0 male 1932 2012
Abbey 0.0017 0.9983 female 1932 2012
Abbie 0.0088 0.9912 female 1932 2012
Abby 0.003 0.997 female 1932 2012
Abdel 1 0 male 1932 2012

You then need to add gender to the salary dataset by merging the gender data frame with the salary data using first names as the unique key. Make sure you do not drop observations from the salary database.

If the name was not found in the US names database the gender will be coded as NA. Replace all of these cases with the label “uncoded”.

d$gender[ is.na(d$gender) ] <- "uncoded"
d$gender <- factor( d$gender, levels=c("male","female","uncoded") )

Step 4: Standardize Job Titles

We are interested in five categories of job titles but the job description field is not standardized across the university. Here is a quick crosswalk, likely missing some cases and with some errors but good enough for a first pass.

Convert these steps into a code_titles() function that can be stored in utils.R.

title <- rep( "", nrow(d) )
title[ grepl( "^Asst Professor$", d$Job.Description ) ]  <- "Assistant Professor"
title[ grepl( "^Assoc Professor$", d$Job.Description ) ] <- "Associate Professor"

title[ grepl( "^Professor$", d$Job.Description ) ]            <- "Full Professor"
title[ grepl( "Regents Professor", d$Job.Description ) ]      <- "Full Professor"
title[ grepl( "President's Professor", d$Job.Description ) ]  <- "Full Professor"

title[ grepl( "^Postdoctoral Research Scholar$", d$Job.Description ) ]   <- "Researcher"
title[ grepl( "Research Specialist", d$Job.Description ) ]               <- "Researcher"
title[ grepl( "Research Analyst", d$Job.Description ) ]                  <- "Researcher"
title[ grepl( "Postdoctoral Scholar", d$Job.Description ) ]              <- "Researcher"
title[ grepl( "Research Scientist", d$Job.Description ) ]                <- "Researcher"
title[ grepl( "Research Professional", d$Job.Description ) ]             <- "Researcher"
title[ grepl( "Research Professor", d$Job.Description ) ]                <- "Researcher"

title[ grepl( "^Instructor$", d$Job.Description ) ]           <- "Teaching Faculty"
title[ grepl( "Clinical .+ Professor", d$Job.Description ) ]  <- "Teaching Faculty"
title[ grepl( "Lecturer$", d$Job.Description ) ]              <- "Teaching Faculty"
title[ grepl( "^Lecturer Sr$", d$Job.Description ) ]          <- "Teaching Faculty"
title[ grepl( "^Principal Lecturer$", d$Job.Description ) ]   <- "Teaching Faculty"
title[ grepl( "Professor of Practice", d$Job.Description ) ]  <- "Teaching Faculty"

d$title <- factor( title, 
                   levels=c("Full Professor","Associate Professor",
                            "Assistant Professor","Teaching Faculty",
                            "Researcher" ) )

Step 5: Convert Salary to Numeric

Note the format of Salaries in the database. Since it has a dollar sign and comma it is understood to be a text field. As a result, we cannot compute basic statistics like the median salary, and we also cannot recast it easily.

head( d$Salary )
## [1] "$111,133.00" "$46,275.00"  "$37,717.00"  "$53,710.00"  "$91,000.00" 
## [6] "$107,160.00"
head( d$Salary ) %>% as.numeric()
## [1] NA NA NA NA NA NA

Write a function to remove the dollar sign and comma from the strings and return a numeric salary vector. Store this in your utils.R file and use it to create a new variable called “salary” (no uppercase S):

d$salary <- convert_currency( d$Salary )

Step 6: Normalize Salary by FTE

We want FTE salaries, or what the salary each person would earn if they are working full-time (FTE=100).

Normalize the new salary variable so that it represents everyone’s FTE salary:

salary <- salary / (d$FTE / 100)
d$salary <- salary

Convert this step into a function and store it in utils.R.

Step 7: Select Sample

Many university units are administrative and not academic, so we need to select a set of academic units for the report. A list is provided for you below.

Drop employees that don’t fit into the defined title categories:

academic.units <- 
c("CISA-Intrdisp Hum & Comm", "CISA-Science & Mathmatics", 
"College of Health Solutions MS", "College of Health Solutions NT", 
"College of Health Solutions SH", "College Of Law", "English", "Hugh Downs School Of Comm", 
"Humanities Arts & Cultural", "Journalism & Mass Comm", "Ldrshp and Integrative Studies", 
"Math & Natural Sciences Div", "MDT Music", "Physics Department", 
"Psychology", "Sch Biological & Hlth Sys Engr", "Sch Compt Infor & Dec Sys Engr", 
"Sch Elect Comptr & Energy Engr", "Sch Engr Matter Trnsprt Energy", 
"Sch Future of Innov in Society", "Sch Sustain Engr & Built Envrn", 
"School Of Art", "School of Criminology & Crim J", "School Of Earth & Space Explor", 
"School of Geog Sci & Urban Pln", "School of Math & Stat Sciences", 
"School of Molecular Sciences", "School of Politics & Global St", 
"School Of Public Affairs", "School of Social Transform", "School Of Social Work", 
"SHPRS History Faculty", "Social & Behavioral Sciences", "Sols Administration & Faculty", 
"SOS Faculty & Researchers", "The Design School", "The Sanford School", 
"WPC Accountancy", "WPC Economics", "WPC Information Systems", 
"WPC Management", "WPC Supply Chain Management")

d2 <- 
  d %>% 
  filter( title != "" & ! is.na(title) ) %>% 
  filter( Department.Description %in% academic.units ) %>% 
  arrange( Department.Description, title )

nrow( d2 )
## [1] 2459
head( d2 ) %>% pander()
Table continues below
first.name Calendar.Year Full.Name Job.Description
Barry 2020 Maid, Barry Professor
Brooks 2020 Simpson, Brooks Professor
Eva 2020 Brumberger, Eva Professor
Ian 2020 Moulton, Ian Professor
Jewell 2020 Rhodes, Jewell Professor
Claire 2020 Lauer, Claire Assoc Professor
Table continues below
Department.Description Salary FTE gender proportion_female
CISA-Intrdisp Hum & Comm $54,050.00 50 male 0.0045
CISA-Intrdisp Hum & Comm $145,610.00 100 male 0.0647
CISA-Intrdisp Hum & Comm $106,350.00 100 female 0.9963
CISA-Intrdisp Hum & Comm $100,000.00 100 male 0.0038
CISA-Intrdisp Hum & Comm $297,000.00 100 female 0.8463
CISA-Intrdisp Hum & Comm $90,150.00 100 female 0.9939
title salary
Full Professor 108100
Full Professor 145610
Full Professor 106350
Full Professor 1e+05
Full Professor 297000
Associate Professor 90150

Step 8: Summarize Salaries

Create a table of salary iq-range (25th quantile to 75th quantile) that is broken out by rank (title) and gender:

The p variable represents the proportion of total employees within each group.

Turn this into a create_salary_table() function and store it in utils.R.

t.salary <- 
  d %>% 
  filter( ! is.na( title ) & title != "" ) %>% 
  group_by( title, gender ) %>% 
  summarize( q25=quantile(salary,0.25),
             q50=quantile(salary,0.50),
             q75=quantile(salary,0.75),
             n=n() ) %>% 
  ungroup() %>% 
  mutate( p= round( n/sum(n), 2) )

pander( t.salary )
title gender q25 q50 q75 n p
Full Professor male 119017 142403 186188 407 0.11
Full Professor female 113673 135299 168334 187 0.05
Full Professor uncoded 129514 150440 183511 68 0.02
Associate Professor male 93872 105000 118000 327 0.09
Associate Professor female 90352 99000 113460 249 0.07
Associate Professor uncoded 94412 107984 117790 67 0.02
Assistant Professor male 82401 93150 100500 202 0.05
Assistant Professor female 80000 85464 95000 198 0.05
Assistant Professor uncoded 83805 95625 100750 88 0.02
Teaching Faculty male 49834 59983 84175 491 0.13
Teaching Faculty female 48736 53739 67089 686 0.18
Teaching Faculty uncoded 49000 55000 73500 81 0.02
Researcher male 50000 59060 72171 345 0.09
Researcher female 50000 55778 69758 281 0.07
Researcher uncoded 50000 55344 67875 134 0.04

Step 9: Graph Results

I have provided you with functions to create graph of salaries of instructors, assistants, associate, and full professors in each unit reporting results by gender.

Note the chunk arguments:

{r, fig.height=7, fig.width=10}
add_position <- function( t, position, y, xmax, scale.f=8 )
{
  
  t.original <- t
  t <- filter( t.original, title==position )
  dot.size <- 2 + scale.f*sum(t$p)
  offset.n <- 1 + sum(t$p)*2
  
  male.median <- NA
  n.male <- NA
  t <- filter( t.original, title==position & gender == "male" )
  if( nrow(t) > 0 )
  { 
    male.median <- t$q50 
    n.male <- t$n
  }

  
  female.median <- NA
  n.female <- NA
  t <- filter( t.original, title==position & gender == "female" )
  if( nrow(t) > 0 )
  { 
    female.median <- t$q50 
    n.female <- t$n
  }

  
  # dumbell plots 
  segments( x0=female.median, x1=male.median, y0=y,
          col=gray(0.3,0.5), lwd=7 )
  points( male.median, y,
          col=adjustcolor( "darkblue", alpha.f = 0.5), 
          pch=19, cex=dot.size  )
  points( female.median, y,
          col=adjustcolor( "firebrick", alpha.f = 0.5), 
          pch=19, cex=dot.size  )
  
  pos.f <- 2
  pos.m <- 4
  if( ! ( is.na(female.median) | is.na(male.median) ) )
  {
    pos.f <- ifelse( female.median > male.median, 4, 2 )
    pos.m <- ifelse( female.median > male.median, 2, 4 )
  }
  
  # add salaries to right and left 
  text( female.median, y, paste0("$",round(female.median/1000,0),"k"),
        col=adjustcolor( "firebrick", alpha.f = 0.7), 
        cex=1.2, pos=pos.f, offset=offset.n )
  text( male.median, y, paste0("$",round(male.median/1000,0),"k"),
        col=adjustcolor( "darkblue", alpha.f = 0.7), 
        cex=1.2, pos=pos.m, offset=offset.n ) 
  
  # add faculty counts
  n.female <- ifelse( is.na(n.female), 0, n.female )
  n.female <- ifelse( nchar(n.female)==1, 
                      paste0( " ", n.female), n.female )
  n.male <- ifelse( is.na(n.male), 0, n.male )
  n.male <- ifelse( nchar(n.male)==1, 
                      paste0( " ", n.male), n.male )
  text( xmax-0.1*xmax, y+0.14, paste0( "f   = ", n.female),
        col="gray50", cex=1.1, pos=4  )
  text( xmax-0.1*xmax, y-0.14, paste0( "m = ", n.male),
        col="gray50", cex=1.1, pos=4  )


  axis( side=2, at=y, labels=position, 
        las=2, tick=F, cex.axis=1.5, col.axis="gray50" )
}


build_graph <- function( t.salary, unit )
{
  unique.titles <- unique( t.salary$title )
  ymax <- length(unique.titles)
  xmax <- round( max(t.salary$q50), -3 ) + 50000
  color.key.pos <- 40000 + ( xmax - 40000 ) / 2
  color.key.inc <- ( xmax - 40000 ) / 10
  
  t.mf <- filter( t.salary, gender %in% c("male","female") )
  N <- sum( t.mf$n )
  
  par( mar=c(6,15,4.1,0) )
  plot.new()
  plot.window( xlim=c(40000-10000,xmax), ylim=c(0,ymax+1) )
  
  abline( v=seq(40000,xmax-40000,20000), lwd=1.5, lty=2, col=gray(0.5,0.5) )
  axis( side=1, 
        at=seq(40000,xmax-40000,20000), 
        labels=paste0("$",seq(40,(xmax-40000)/1000,20),"k"),
        cex.axis=1.1, col.axis="gray40", tick=FALSE )
  
  y <- ymax
  
  if( "Full Professor" %in% unique.titles )
  {
    add_position( t.salary, position="Full Professor", y, xmax )
    y <- y-1
  }
  if( "Associate Professor" %in% unique.titles )
  {
    add_position( t.salary, position="Associate Professor", y, xmax )
    y <- y-1
  }
  if( "Assistant Professor" %in% unique.titles )
  {
    add_position( t.salary, position="Assistant Professor", y, xmax )
    y <- y-1
  }
  if( "Teaching Faculty" %in% unique.titles )
  {
    add_position( t.salary, position="Teaching Faculty", y, xmax )
    y <- y-1
  }
  if( "Researcher" %in% unique.titles )
  {
    add_position( t.salary, position="Researcher", y, xmax )
    y <- y-1
  }

  
  text( color.key.pos + 3*color.key.inc, 0, "MALE", 
        col=adjustcolor( "darkblue", alpha.f = 0.7), cex=1.2 )
  text( color.key.pos + 1.8*color.key.inc, 0, "FEMALE", 
        col="firebrick",  cex=1.2 )
  text( xmax - 0.1*xmax, 0, paste0("N = ",N), col="gray40",  cex=1.2, pos=4 )

  
  title( main="Median Salary by Rank and Gender", cex.main=1.5, col.main="gray30" )
  title( xlab=unit, col.lab="gray50", cex.lab=1.5, line=5 )
  title( xlab="dot size represents proportion of faculty at that rank",
         col.lab="gray50", cex.lab=0.9 )
  
  return(NULL)
}



### TEST: 
#   t.salary is the salary table from the previous step
#   unit is a category from Department.Description
#
#     build_graph( t.salary, unit="Psychology" )
#


d2 %>%  
  filter( Department.Description == "Psychology" ) %>% 
  create_table( ) %>% 
  build_graph( unit="Psychology" )

NULL

Step 10 - Top Five Salaries

Create function that generates a table of the top 5 salaries and reports the name, gender, position, and salary of each person on the list.

You might find the following formatting function helpful:

dollarize <- function(x)
{ paste0("$", format( round( x, 0 ), big.mark="," ) ) }

dollarize( x=150000 )
## [1] "$150,000"
Full.Name gender Job.Description salary
Prescott, Edward male Regents Professor $436,101
LePine, Jeffery male Professor $402,257
Panchanathan, Sethuraman uncoded Professor $365,000
Gomez-Mejia, Luis male Regents Professor $361,393
Navrotsky, Alexandra female Professor $358,209

Put it All Together

Automate the process using a loop to isolate data from each unit, create the two tables and the graph, then add them to the document.

for( i in academic.units )
{
  
  d3 <- filter( d2, Department.Description == i )
  # create the salary summary by rank & gender table 
  # create the top 5 salaries table 
  # build the graph 

  # print the tables:  
  # cat( paste('<h3>',"TOP FIVE SALARIES",'</h3>' ) )
  # cat( t.rank %>% knitr::kable(format="html") )   

  # cat( '<br><hr><br>' )
  
}

Name this file “functions-demo.rmd”.

The rendered HTML file will serve as the documentation of your process. It should load the 2020 data and will also include all of the custom functions you created. Do NOT hide your code in this file and demo each function with some test data to show they are working.

In the next step you will create a generic report template (salary-report.rmd) which sources the functions from utils.R and has a generic data load step so you can re-use the template with different years of data (see steps 11-13 below).

Note, the knitr package has a function called kable that will output nice HTML tables.You can add HTML tables to the RMD through the chunk, then render them to produce nicely-formatted results.

cat( t.rank %>% knitr::kable(format="html") )

You need to include the chunk argument results=‘asis’ and in order to return the raw text from inside a loop you need to use cat() instead of print():

{r, fig.height=7, fig.width=10, results="asis"}

Step 11: Create a Generic Salary Report Template

Once you have completed all of these steps you are ready to create your salary report template. It is generic because it will create the same report using different years of data.

Create an RMD template called salary-report.rmd.

You will build a report using the render function in the rmarkdown package (this is what is called when you “knit” your RMD doc in R Studio):

rmarkdown::render( input='salary-report.rmd', 
                   output_file = "ASU-2020-Salary-Report.HTML",
                   params = # 2020 data url )

Copy all of your new functions into a utils.R file (in R Studio you can use the top menu bar and select File >> New File >> R Script then save it as utils.R).

In the chunk where you load packages add a command to source utils.R to load your custom functions.

library( dplyr )
...
source( 'utils.R' )

Make the data load step generic so you can change the input data at the rmarkdown::render stage (see Step 13 for more details):

URL <- params$url
d <- read.csv( URL )

Include each step needed to clean, augment, and analyze the data. Include a loop at the end that generates a report section for each academic unit.

DETAILS:

The salary-report.rmd template serves the same purpose as the Resume.rmd template on Lab 6. It sources your custom scripts (parsin_functions.R in the resume example), loads the data (positions.csv), then calls the custom functions to add content to each section.

https://github.com/DS4PS/cv/blob/master/resume.Rmd

source('parsing_functions.R')

position_data <- read_csv('positions.csv')


## Education {data-icon=graduation-cap data-concise=true}

'''{r}
position_data %>% print_section('education')
'''


## Selected Writing {data-icon=newspaper}

'''{r}
position_data %>% print_section('writings')
'''

Your template will have a similar structure:

source( 'utils.R' )   # load custom functions 

URL <- params$url
d <- read.csv( URL )  # load data 


# PSYCHOLOGY

'''{r}
d %>%  
  filter( Department.Description == "Psychology" ) %>% 
  create_salary_table(  ) %>% 
  build_graph( unit="Psychology" )
'''
  
## PAY RANGE BY RANK AND GENDER

'''{r}
d %>% 
  filter( Department.Description == "Psychology" ) %>% 
  create_salary_table(  )
'''

## TOP 5 SALARIES 

etc...

Except you will loop through all academic units:

source( 'utils.R' )

URL <- params$url
d <- read.csv( URL )


for( i in academic.units )
{
  
  cat( paste('<h1>', i ,'</h1>' ) )
  
  d %>%  
    filter( Department.Description == i ) %>% 
    create_salary_table() %>% 
    build_graph( unit=i )  

  cat( paste('<h3>', 'PAY RANGE BY RANK AND GENDER' ,'</h3>' ) )

  t.salary <- 
    d %>% 
    filter( Department.Description == "Psychology" ) %>% 
    create_salary_table()
    
  cat( t.salary %>% knitr::kable(format="html") )

  # etc...

  cat( '<br><hr><br>' )
  
}

Step 12: Customize Your CSS

Customize your salary-report.rmd by adding a CSS section at the end. Change the color of your headers and add some spacing to the tables.

# pretty tables 

td {
    padding: 3px 15px 3px 15px;
    text-align: center !important;
}

th {
    padding: 3px 15px 3px 15px;
    text-align: center !important;
    font-weight: bold;
    color: SlateGray !important;
}

Step 13: Batch Processing by Year

We are going to batch process multiple years of reports using functionality in the rmarkdown package.

Batch Process Script:

Create a new R script called "“batch.R”.

This script will render a new report using salary-report.rmd, one for each year. The batch.R file calls the RMD template file, and the RMD template file in-turn sources the custom functions and loads the data.

So your files are chained together as follows:

batch.R 
├── render( pass 2020 data url )
│   ├── salary-template.rmd
│       ├── source( 'utils.R' )
│       ├── read.csv( params$url.2020 )
├── render( pass 2019 data url )
│   ├── salary-template.rmd
│       ├── source( 'utils.R' )
│       ├── read.csv( params$url.2019 )
├── render( pass 2018 data url )
│   ├── salary-template.rmd
│       ├── source( 'utils.R' )
│       ├── read.csv( params$url.2018 )

Get the URL For Each Year

Note that so far we have been working with the 2020 salary data that was loaded directly in the RMD doc:

URL <- 'https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/export?gid=1335284952&format=csv'
d <- read.csv( URL )

The State Press google spreadsheet has multiple years of data organized by tabs. Each tab has a unique URL:

# https://docs.google.com/spreadsheets/d/<KEY>/export?gid=<GID>&format=csv
# where <KEY> and <GID> can be obtained from your navigation's URL,
# https://docs.google.com/spreadsheets/d/<KEY>/edit#gid=<GID>

# NEED DIFFERENT <gid> FOR EACH SHEET
# 2019 sheet:  https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/edit#gid=1948400967
# 2018 sheet:  https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/edit#gid=169937930 
# etc

Generalize the Data URL in the RMD template:

Currently we have a single year of data hard-coded inside the template.

URL <- 'https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/export?gid=1335284952&format=csv'
d <- read.csv( URL )

We want to change this to a generic URL variable that we can change each time we create a new report.

Add a new params URL field in your YAML header:

---
title: 'CPP 527 Final Project Instructions'
output:
  html_document:
    theme: readable
    highlight: zenburn
    toc: true
params:
  url:
    value: x   
---

Change the data load step in your file from an absolute URL to a variable reference.

We can reference the YAML url field in this way:

URL <- params$url
d <- read.csv( URL )

The YAML fields in the RMD doc are like argument defaults, but they can be replaced using the params argument in rmarkdown::render inside your batch.R file:

#######################################
#######################################
#####                             #####
#####       BATCH.R FILE          #####
#####                             #####
#######################################
#######################################


## 2020 REPORT

url.2020 <- "https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/export?gid=1335284952&format=csv"
rmarkdown::render( input='salary-report.rmd', 
                   output_file = "ASU-2020-Salary-Report.HTML",
                   params = list( url = url.2020 ) )

## 2019 REPORT 

url.2019 <- "https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/edit#gid=1948400967"
rmarkdown::render( input='salary-report.rmd', 
                   output_file = "ASU-2019-Salary-Report.HTML",
                   params = list( url = url.2019 ) )


Instructions:

Find the proper URLs for years 2016-2020.

Use your batch.R file to create a separate report for each year.



Submission Instructions

Deliverables

You have the following files:

  • utils.R - contains all of your helper functions
  • function-demo.rmd, function-demo.html - show each helper function in action
  • salary-report.rmd - report template
  • batch.R - generates reports for all years
  • five rendered HTML reports:
    • “ASU-2020-Salary-Report.HTML”
    • “ASU-2019-Salary-Report.HTML”
    • “ASU-2018-Salary-Report.HTML”
    • “ASU-2017-Salary-Report.HTML”
    • “ASU-2016-Salary-Report.HTML”

The relationship between files:

function-demo.rmd 
├── output: function-demo.html

batch.R 
├── render( salary-template.rmd ) # 2020 data
│       ├── source( 'utils.R' )
│       ├── output: ASU-2020-Salary-Report.HTML

├── render( salary-template.rmd ) # 2019 data
│       ├── source( 'utils.R' )
│       ├── output: ASU-2019-Salary-Report.HTML

├── render( salary-template.rmd ) # 2018 data
│       ├── source( 'utils.R' )
│       ├── output: ASU-2018-Salary-Report.HTML

In the function-demo.rmd file include all of your code and demo each function from Steps 1-10 above so I can see they are working properly.

The salary-report.rmd file, on the other hand, will hide the code so that it generates a clean report. Make sure to suppress warnings and messages as well. The knitr options argument is helpful:

knitr::opts_chunk$set( echo=F, message=F, warning=F )

Submission

Zip the nine files above into a project directory and upload to canvas.

Name your files: CPP-527-FINAL-LastName.zip





Report Demo

CISA-Intrdisp Hum & Comm

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Rhodes, Jewell female Professor $297,000
Simpson, Brooks male Professor $145,610
Maid, Barry male Professor $108,100
Brumberger, Eva female Professor $106,350
Moulton, Ian male Professor $100,000

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $104,050 $108,100 $126,855 3 0.07
Full Professor female $154,012 $201,675 $249,338 2 0.04
Associate Professor male $ 94,612 $ 94,612 $ 94,612 1 0.02
Associate Professor female $ 88,762 $ 89,225 $ 89,688 2 0.04
Assistant Professor male $ 73,512 $ 74,025 $ 74,512 3 0.07
Assistant Professor female $ 72,100 $ 72,200 $ 74,375 3 0.07
Assistant Professor uncoded $ 65,000 $ 65,000 $ 65,000 1 0.02
Teaching Faculty male $ 48,218 $ 48,740 $ 48,897 9 0.20
Teaching Faculty female $ 47,338 $ 48,845 $ 51,706 20 0.44
Teaching Faculty uncoded $ 48,980 $ 48,980 $ 48,980 1 0.02


CISA-Science & Mathmatics

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Sagers, Cynthia female Professor $123,750
Zandieh, Michelle female Professor $113,288
Shovkovy, Igor male Professor $107,675
Kang, Yun female Professor $103,330
Sukharev, Maxim male Professor $103,096

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $104,241 $105,386 $106,530 2 0.05
Full Professor female $108,309 $113,288 $118,519 3 0.08
Associate Professor male $ 89,752 $ 95,208 $ 95,847 3 0.08
Associate Professor female $ 93,698 $ 94,882 $ 96,066 2 0.05
Associate Professor uncoded $ 90,333 $ 90,333 $ 90,333 1 0.03
Assistant Professor male $ 82,780 $ 83,628 $ 84,814 3 0.08
Assistant Professor female $ 81,357 $ 82,714 $ 84,070 2 0.05
Assistant Professor uncoded $ 84,536 $ 85,024 $ 85,512 2 0.05
Teaching Faculty male $ 48,925 $ 50,000 $ 58,082 9 0.24
Teaching Faculty female $ 48,686 $ 48,925 $ 56,949 7 0.18
Teaching Faculty uncoded $ 48,106 $ 48,350 $ 49,275 3 0.08
Researcher female $ 58,000 $ 58,000 $ 58,000 1 0.03


College of Health Solutions MS

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Gaesser, Glenn male Professor $162,943
Adams, Marc male Assoc Professor $120,280
Siegler, Jason male Assoc Professor $115,000
Huberty, Jennifer female Assoc Professor $103,650
Peterson, Daniel male Asst Professor $ 98,500

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $162,943 $162,943 $162,943 1 0.03
Associate Professor male $ 97,398 $115,000 $117,640 3 0.09
Associate Professor female $ 92,248 $ 93,299 $ 96,112 4 0.12
Assistant Professor male $ 92,125 $ 94,250 $ 96,375 2 0.06
Assistant Professor female $ 88,000 $ 88,000 $ 88,000 1 0.03
Teaching Faculty male $ 53,062 $ 59,000 $ 63,550 7 0.22
Teaching Faculty female $ 54,500 $ 55,215 $ 57,482 11 0.34
Researcher female $ 48,789 $ 50,000 $ 51,352 3 0.09


College of Health Solutions NT

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Ohri-Vachaspati, Punam female Professor $165,543
Wang, Shu male Professor $160,000
Banks, Dorothy female Professor $140,000
Bruening, Meredith female Assoc Professor $120,280
Vega-Lopez, Sonia female Assoc Professor $113,460

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $160,000 $160,000 $160,000 1 0.03
Full Professor female $146,386 $152,772 $159,157 2 0.06
Associate Professor female $105,589 $106,665 $113,460 5 0.16
Assistant Professor female $ 89,000 $ 89,000 $ 89,000 1 0.03
Assistant Professor uncoded $ 94,700 $ 94,700 $ 94,700 1 0.03
Teaching Faculty female $ 54,125 $ 58,600 $ 63,792 17 0.55
Researcher male $ 48,113 $ 48,742 $ 49,371 2 0.06
Researcher female $ 63,650 $ 66,100 $ 68,550 2 0.06


College of Health Solutions SH

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Yost, William male Research Professor (FSC) $189,888
Scherer, Nancy female Professor $156,634
Gray, Shelley female Professor $147,400
Berisha, Visar uncoded Assoc Professor $118,400
Schatzki, MariaRita uncoded Clinical Assoc Professor (FSC) $106,308

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor female $149,708 $152,017 $154,326 2 0.06
Associate Professor male $101,397 $101,397 $101,397 1 0.03
Associate Professor female $100,354 $101,709 $101,854 3 0.10
Associate Professor uncoded $118,400 $118,400 $118,400 1 0.03
Assistant Professor male $ 98,000 $ 98,000 $ 98,000 1 0.03
Assistant Professor female $ 98,050 $ 98,200 $ 98,350 2 0.06
Teaching Faculty female $ 77,500 $ 80,000 $ 84,780 13 0.42
Teaching Faculty uncoded $106,308 $106,308 $106,308 1 0.03
Researcher male $ 39,520 $ 41,600 $115,744 3 0.10
Researcher female $ 49,430 $ 51,652 $ 55,943 4 0.13


College Of Law

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Bodansky, Daniel male Regents Professor $274,000
Banks, Angela female Professor $255,250
Roberts, Lawrence male Professor of Practice $250,000
Selmi, Michael male Professor $225,000
Saks, Michael male Regents Professor $222,549

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $165,754 $169,350 $183,774 14 0.30
Full Professor female $160,841 $162,996 $174,498 6 0.13
Associate Professor male $135,750 $138,000 $151,869 6 0.13
Associate Professor female $149,830 $156,460 $156,476 3 0.06
Associate Professor uncoded $ 93,876 $ 93,876 $ 93,876 1 0.02
Teaching Faculty male $ 68,000 $103,710 $214,000 9 0.19
Teaching Faculty female $ 67,250 $ 68,000 $ 87,500 6 0.13
Teaching Faculty uncoded $150,000 $150,000 $150,000 1 0.02
Researcher male $ 45,000 $ 45,000 $ 45,000 1 0.02


English

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Bate, Andrew male Professor $250,000
Diaz, Natalie female Assoc Professor $210,200
Justice, George male Professor $186,000
Bjork, Robert male Professor $163,750
Looser, Devoney female Professor $160,387

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $105,893 $116,259 $138,985 19 0.13
Full Professor female $111,050 $122,425 $130,020 13 0.09
Associate Professor male $ 92,994 $ 93,820 $ 95,142 11 0.07
Associate Professor female $ 88,408 $ 95,862 $ 97,316 9 0.06
Assistant Professor male $ 78,900 $ 79,500 $ 80,000 5 0.03
Assistant Professor female $ 80,046 $ 81,246 $ 82,131 8 0.05
Assistant Professor uncoded $102,000 $102,000 $102,000 1 0.01
Teaching Faculty male $ 49,000 $ 52,100 $ 52,600 32 0.21
Teaching Faculty female $ 49,000 $ 52,600 $ 52,600 46 0.31
Teaching Faculty uncoded $ 49,000 $ 51,600 $ 52,600 5 0.03


Hugh Downs School Of Comm

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Lederman, Linda female Professor $220,000
Tracy, Sarah female Professor $135,670
Corman, Steven male Professor $130,500
Alberts, Janet female President’s Professor $129,300
Roberto, Anthony male Professor $119,450

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $115,870 $119,450 $124,975 3 0.06
Full Professor female $111,178 $120,955 $134,078 6 0.11
Associate Professor male $ 95,050 $ 97,700 $ 98,185 3 0.06
Associate Professor female $100,600 $100,600 $100,600 1 0.02
Associate Professor uncoded $ 89,907 $ 89,978 $ 90,048 2 0.04
Assistant Professor male $ 74,500 $ 74,500 $ 74,500 1 0.02
Assistant Professor female $ 75,350 $ 76,700 $ 78,350 3 0.06
Assistant Professor uncoded $ 77,300 $ 77,300 $ 77,300 1 0.02
Teaching Faculty male $ 46,890 $ 47,190 $ 47,190 13 0.24
Teaching Faculty female $ 45,000 $ 47,050 $ 47,190 20 0.37
Teaching Faculty uncoded $ 46,200 $ 46,200 $ 46,200 1 0.02


Humanities Arts & Cultural

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Matustik, Martin male Professor $138,300
Brashears, William male Clinical Asst Professor (FSC) $116,400
Pagan, Eduardo male Assoc Professor $114,900
Lerman, Richard male Professor $106,390
Hanlon, Christopher male Professor $105,275

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $103,656 $105,832 $114,368 4 0.08
Full Professor female $ 97,540 $ 99,556 $100,198 6 0.12
Associate Professor male $ 88,016 $ 88,335 $ 91,288 8 0.15
Associate Professor female $ 85,325 $ 86,620 $ 88,704 10 0.19
Assistant Professor male $ 75,830 $ 75,830 $ 75,830 1 0.02
Assistant Professor female $ 75,750 $ 75,750 $ 75,750 1 0.02
Teaching Faculty male $ 48,300 $ 48,470 $ 77,845 5 0.10
Teaching Faculty female $ 46,800 $ 48,550 $ 48,712 15 0.29
Teaching Faculty uncoded $ 48,338 $ 50,546 $ 52,753 2 0.04


Journalism & Mass Comm

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Misner, John male Professor of Practice (FSC) $196,223
Beelman, Maud female Professor of Practice (FSC) $185,000
Cohen, Sarah female Professor $157,579
Wallace, Julia female Professor of Practice $156,259
Downie, Leonard male Professor of Practice $155,448

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $ 93,289 $ 95,845 $111,393 3 0.07
Full Professor female $157,579 $157,579 $157,579 1 0.02
Associate Professor male $ 70,154 $ 70,963 $ 75,479 3 0.07
Associate Professor female $ 74,789 $ 80,611 $ 88,440 6 0.14
Associate Professor uncoded $ 89,635 $ 89,635 $ 89,635 1 0.02
Assistant Professor male $ 69,216 $ 70,122 $ 71,027 2 0.05
Assistant Professor female $ 67,591 $ 67,591 $ 67,591 1 0.02
Teaching Faculty male $ 92,362 $120,866 $142,197 12 0.27
Teaching Faculty female $104,105 $115,591 $143,440 15 0.34


Ldrshp and Integrative Studies

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Akpan, Patience female Assoc Professor $89,000
Bates, Denise female Asst Professor $73,429
Giron, Angela female Clinical Asst Professor (FSC) $71,722
Castillo, Elizabeth female Asst Professor $70,749
Trinh, Mai female Asst Professor $70,740

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Associate Professor male $43,985 $43,985 $43,985 1 0.03
Associate Professor female $89,000 $89,000 $89,000 1 0.03
Assistant Professor male $70,653 $70,653 $70,653 1 0.03
Assistant Professor female $70,744 $70,749 $72,089 3 0.08
Teaching Faculty male $48,524 $49,623 $53,936 16 0.42
Teaching Faculty female $48,839 $50,796 $54,494 14 0.37
Teaching Faculty uncoded $47,080 $47,159 $47,238 2 0.05


Math & Natural Sciences Div

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Dietrich, Suzanne female Professor $127,995
Camacho, Erika female Professor $121,440
Kanthaswamy, Sreetharan uncoded Professor $117,645
Sullivan, Brian male Professor $111,420
Marshall, Pamela female Professor $107,234

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $ 91,243 $104,397 $105,975 5 0.08
Full Professor female $114,337 $121,440 $124,718 3 0.05
Full Professor uncoded $100,774 $106,398 $112,022 2 0.03
Associate Professor male $ 89,577 $ 90,402 $ 91,915 5 0.08
Associate Professor female $ 95,773 $ 97,358 $ 98,546 4 0.06
Associate Professor uncoded $100,166 $100,166 $100,166 1 0.02
Assistant Professor male $ 86,750 $ 87,000 $ 88,077 4 0.06
Assistant Professor female $ 88,000 $ 90,000 $ 91,599 5 0.08
Assistant Professor uncoded $ 89,062 $ 91,125 $ 93,188 2 0.03
Teaching Faculty male $ 45,000 $ 47,275 $ 55,250 12 0.19
Teaching Faculty female $ 45,000 $ 47,450 $ 53,322 16 0.26
Teaching Faculty uncoded $ 57,684 $ 57,684 $ 57,684 1 0.02
Researcher male $ 62,600 $ 62,600 $ 62,600 1 0.02
Researcher uncoded $ 60,000 $ 60,000 $ 60,000 1 0.02


MDT Music

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Marshall, Kimberly female Professor $121,288
Roumain, Daniel male Professor of Practice, MY $121,185
Spring, Robert male Professor $115,305
Meyer, Jeffery male Assoc Professor $112,325
DeMaris, Brian male Assoc Professor $109,184

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $87,016 $92,271 $ 94,935 13 0.20
Full Professor female $87,690 $92,661 $ 94,540 7 0.11
Full Professor uncoded $91,886 $91,886 $ 91,886 1 0.02
Associate Professor male $84,210 $91,956 $102,092 7 0.11
Associate Professor female $73,313 $76,250 $ 77,679 6 0.09
Assistant Professor male $63,254 $65,072 $ 72,190 11 0.17
Assistant Professor female $63,145 $64,666 $ 70,575 6 0.09
Teaching Faculty male $54,625 $63,549 $ 74,504 10 0.15
Teaching Faculty female $58,056 $65,251 $ 69,239 4 0.06


Physics Department

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Ritchie, Barry male Professor $233,201
Nemanich, Robert male Regents Professor $210,580
Smith, David male Regents Professor $184,222
Spence, John male Regents Professor $184,200
Liu, Jingyue uncoded Professor $180,825

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $120,494 $140,799 $175,535 18 0.26
Full Professor female $112,269 $112,880 $113,490 2 0.03
Full Professor uncoded $104,376 $118,932 $149,878 3 0.04
Associate Professor male $108,413 $111,662 $114,505 8 0.11
Associate Professor female $105,700 $105,700 $105,700 1 0.01
Assistant Professor male $ 92,000 $ 92,500 $ 92,800 5 0.07
Assistant Professor female $ 93,500 $ 93,500 $ 93,650 3 0.04
Teaching Faculty male $ 46,667 $ 46,667 $ 46,667 1 0.01
Teaching Faculty female $ 58,200 $ 58,200 $ 58,200 1 0.01
Researcher male $ 51,500 $ 55,800 $ 78,800 14 0.20
Researcher female $ 47,957 $ 50,450 $ 51,563 6 0.09
Researcher uncoded $ 47,476 $ 49,700 $ 51,498 8 0.11


Psychology

TOP FIVE SALARIES

Full.Name gender Job.Description salary
McNamara, Danielle female Professor $227,000
Chassin, Laurie female Regents Professor $226,418
Eisenberg, Nancy female Regents Professor $200,336
Mackinnon, David male Professor $177,750
Kenrick, Douglas male President’s Professor $176,765

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $121,920 $133,778 $164,629 14 0.18
Full Professor female $145,685 $161,320 $206,856 8 0.10
Full Professor uncoded $116,114 $118,250 $120,386 2 0.03
Associate Professor male $ 98,000 $106,250 $112,619 9 0.12
Associate Professor female $108,367 $113,215 $121,520 5 0.06
Associate Professor uncoded $111,780 $111,780 $111,780 1 0.01
Assistant Professor female $ 92,000 $ 92,750 $ 93,875 6 0.08
Assistant Professor uncoded $ 92,000 $ 92,000 $ 92,000 1 0.01
Teaching Faculty male $ 80,702 $ 85,175 $ 88,888 4 0.05
Teaching Faculty female $ 56,762 $ 59,167 $ 61,322 4 0.05
Teaching Faculty uncoded $ 57,192 $ 57,795 $ 58,398 2 0.03
Researcher male $ 56,352 $ 60,000 $ 84,443 3 0.04
Researcher female $ 50,004 $ 52,251 $ 78,000 17 0.22
Researcher uncoded $ 90,534 $108,289 $126,044 2 0.03


Sch Biological & Hlth Sys Engr

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Kleim, Jeffrey male Assoc Professor $159,301
Tyler, William male Assoc Professor $148,600
Lockhart, Thurmon male Professor $135,000
Stabenfeldt, Sarah female Assoc Professor $125,833
Sadleir, Rosalind female Assoc Professor $124,428

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $135,000 $135,000 $135,000 1 0.02
Associate Professor male $107,706 $117,972 $121,982 11 0.26
Associate Professor female $124,058 $124,428 $125,130 3 0.07
Associate Professor uncoded $111,557 $111,557 $111,557 1 0.02
Assistant Professor male $ 97,250 $ 98,000 $103,692 4 0.10
Assistant Professor female $100,365 $102,126 $103,617 4 0.10
Assistant Professor uncoded $ 97,000 $ 98,000 $ 98,000 3 0.07
Teaching Faculty male $ 72,878 $ 74,357 $ 75,836 2 0.05
Teaching Faculty female $ 73,185 $ 73,185 $ 73,185 1 0.02
Researcher male $ 49,885 $ 50,000 $ 52,500 5 0.12
Researcher female $ 54,500 $ 55,000 $ 79,000 3 0.07
Researcher uncoded $ 50,003 $ 50,502 $ 51,770 4 0.10


Sch Compt Infor & Dec Sys Engr

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Panchanathan, Sethuraman uncoded Professor $365,000
VanLehn, Kurt male Professor $240,565
Kambhampati, Subbarao uncoded Professor $224,719
Liu, Huan male Professor $211,536
Mirchandani, Pitu uncoded Professor $206,710

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $159,077 $180,960 $201,125 10 0.11
Full Professor female $144,750 $147,500 $150,250 2 0.02
Full Professor uncoded $156,918 $177,231 $200,075 11 0.12
Associate Professor male $108,716 $126,500 $130,815 8 0.09
Associate Professor female $104,035 $111,735 $114,165 3 0.03
Associate Professor uncoded $106,760 $115,127 $121,603 6 0.07
Assistant Professor male $101,450 $104,400 $109,750 11 0.12
Assistant Professor female $102,750 $105,500 $107,750 3 0.03
Assistant Professor uncoded $106,875 $112,500 $113,625 6 0.07
Teaching Faculty male $ 79,552 $ 85,000 $ 89,446 9 0.10
Teaching Faculty female $ 54,375 $ 82,500 $ 90,699 7 0.08
Teaching Faculty uncoded $ 94,966 $ 98,506 $ 99,805 4 0.05
Researcher male $ 80,107 $ 97,587 $121,669 6 0.07
Researcher female $ 70,886 $ 71,771 $ 72,656 2 0.02


Sch Elect Comptr & Energy Engr

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Vittal, Vijay male Regents Professor $298,000
Lai, Ying-Cheng uncoded Professor $270,200
Kiaei, Sayfe uncoded Professor $264,880
Meldrum, Deirdre female Professor $235,250
Balanis, Constantine male Regents Professor $221,879

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $125,870 $160,888 $172,700 17 0.17
Full Professor female $154,620 $160,298 $177,500 8 0.08
Full Professor uncoded $143,667 $171,328 $202,000 10 0.10
Associate Professor male $116,660 $119,340 $126,580 9 0.09
Associate Professor female $116,378 $118,065 $120,885 4 0.04
Associate Professor uncoded $107,900 $107,959 $112,570 3 0.03
Assistant Professor male $ 98,000 $103,000 $105,000 11 0.11
Assistant Professor female $108,500 $108,500 $108,500 1 0.01
Assistant Professor uncoded $ 99,375 $102,750 $105,375 6 0.06
Teaching Faculty male $ 75,500 $ 77,000 $ 78,750 3 0.03
Teaching Faculty female $ 80,000 $ 80,000 $ 80,000 1 0.01
Researcher male $ 60,312 $ 65,000 $ 70,526 20 0.20
Researcher uncoded $ 53,500 $ 55,000 $ 62,960 7 0.07


Sch Engr Matter Trnsprt Energy

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Adrian, Ronald male Regents Professor $302,352
Chattopadhyay, Aditi female Regents Professor $292,157
Dahm, Werner male Professor $248,748
Lin, Jerry male Regents Professor $218,200
Friesen, Cody male Assoc Professor $202,250

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $143,412 $152,347 $162,632 18 0.16
Full Professor female $211,789 $238,578 $265,368 2 0.02
Full Professor uncoded $134,802 $147,042 $156,154 4 0.04
Associate Professor male $113,643 $117,900 $126,062 11 0.10
Associate Professor female $112,709 $116,429 $119,550 5 0.04
Associate Professor uncoded $104,658 $116,033 $121,064 8 0.07
Assistant Professor male $ 97,500 $ 99,500 $100,500 9 0.08
Assistant Professor female $102,190 $103,380 $104,190 3 0.03
Assistant Professor uncoded $ 96,625 $ 98,000 $101,250 10 0.09
Teaching Faculty male $ 44,000 $ 80,000 $ 84,000 9 0.08
Teaching Faculty uncoded $ 74,750 $ 76,000 $ 77,250 2 0.02
Researcher male $ 50,000 $ 51,500 $ 55,000 17 0.15
Researcher female $ 50,172 $ 51,443 $ 55,722 3 0.03
Researcher uncoded $ 47,476 $ 48,738 $ 50,500 12 0.11


Sch Future of Innov in Society

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Cook-Deegan, Robert male Professor $204,480
Barab, Sasha female Professor $199,896
Michael, Katina female Professor $179,725
Martin, Paul male Research Professional FSC $169,538
Mayes, Kristin female Professor of Practice (FSC) $162,742

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $155,287 $155,969 $180,224 3 0.07
Full Professor female $184,768 $189,810 $194,853 2 0.04
Associate Professor male $ 95,728 $102,467 $108,301 3 0.07
Associate Professor female $ 98,723 $100,647 $102,843 3 0.07
Associate Professor uncoded $113,874 $113,874 $113,874 1 0.02
Assistant Professor male $ 94,015 $ 94,264 $ 94,512 2 0.04
Assistant Professor female $ 85,850 $ 88,501 $ 92,880 8 0.18
Assistant Professor uncoded $ 92,700 $ 92,700 $ 92,700 1 0.02
Teaching Faculty male $ 60,804 $ 74,882 $100,538 4 0.09
Teaching Faculty female $ 87,939 $103,138 $158,386 7 0.16
Researcher male $ 47,500 $ 70,000 $107,190 7 0.16
Researcher female $ 57,250 $ 74,770 $100,146 4 0.09


Sch Sustain Engr & Built Envrn

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Kavazanjian, Edward male Regents Professor $260,500
Westerhoff, Paul male Regents Professor $255,300
Hjelmstad, Keith male President’s Professor $253,100
Allenby, Braden male President’s Professor $243,400
Lackner, Klaus male Professor $228,900

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $138,620 $195,798 $245,825 12 0.16
Full Professor uncoded $140,527 $144,645 $147,469 4 0.05
Associate Professor male $107,332 $112,300 $125,400 11 0.15
Associate Professor female $108,925 $111,650 $116,075 3 0.04
Associate Professor uncoded $110,375 $111,350 $112,145 4 0.05
Assistant Professor male $ 96,600 $ 99,100 $101,500 5 0.07
Assistant Professor female $ 97,900 $ 97,900 $ 99,350 3 0.04
Assistant Professor uncoded $ 97,000 $ 97,400 $ 99,350 4 0.05
Teaching Faculty male $ 76,425 $ 80,750 $ 87,100 4 0.05
Teaching Faculty female $ 79,000 $ 79,000 $ 79,000 1 0.01
Teaching Faculty uncoded $ 79,400 $ 79,400 $ 79,400 1 0.01
Researcher male $ 50,505 $ 60,000 $ 70,395 10 0.14
Researcher female $ 55,000 $ 66,250 $ 76,534 4 0.05
Researcher uncoded $ 58,750 $ 60,300 $ 63,250 8 0.11


School Of Art

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Klett, Mark male Regents Professor $146,336
Weiser, Kurt male Regents Professor $140,243
Jenik, Adriene female Professor $125,174
Lawson, Shawn male Assoc Professor $118,000
Codell, Julie female Professor $113,462

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $87,681 $90,912 $106,227 9 0.18
Full Professor female $90,742 $92,433 $106,221 11 0.22
Associate Professor male $76,732 $77,820 $ 97,910 3 0.06
Associate Professor female $74,898 $81,018 $ 85,000 9 0.18
Assistant Professor male $64,000 $64,000 $ 64,000 1 0.02
Assistant Professor female $64,150 $65,133 $ 66,155 5 0.10
Assistant Professor uncoded $64,500 $64,500 $ 64,500 1 0.02
Teaching Faculty male $46,925 $47,950 $ 48,975 2 0.04
Teaching Faculty female $45,900 $53,472 $ 63,750 10 0.20


School of Criminology & Crim J

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Spohn, Cassia female Regents Professor $226,000
White, Michael male Professor $173,538
Maguire, Edward male Professor $163,500
Hepburn, John male Professor $143,213
Reisig, Michael male Professor $142,300

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $142,985 $153,356 $166,010 4 0.11
Full Professor female $145,251 $172,168 $199,084 2 0.05
Associate Professor male $100,688 $101,938 $103,753 4 0.11
Associate Professor female $100,148 $101,000 $101,250 5 0.13
Associate Professor uncoded $110,000 $110,000 $110,000 1 0.03
Assistant Professor male $ 84,050 $ 84,100 $ 84,150 2 0.05
Assistant Professor female $ 83,750 $ 84,100 $ 84,400 4 0.11
Teaching Faculty male $ 48,500 $ 51,000 $ 58,250 11 0.29
Teaching Faculty female $ 53,000 $ 53,000 $ 54,000 5 0.13


School Of Earth & Space Explor

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Bell, James male Professor $222,400
Christensen, Philip male Regents Professor $216,050
Windhorst, Rogier uncoded Regents Professor $189,950
Anbar, Ariel female President’s Professor $189,800
Timmes, Francis male Professor $188,705

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $136,306 $146,531 $168,300 19 0.19
Full Professor female $189,800 $189,800 $189,800 1 0.01
Full Professor uncoded $155,527 $167,002 $178,476 2 0.02
Associate Professor male $112,612 $113,100 $120,050 3 0.03
Associate Professor female $114,156 $119,050 $121,250 5 0.05
Associate Professor uncoded $127,966 $129,183 $130,400 2 0.02
Assistant Professor male $ 92,000 $ 96,000 $ 98,200 5 0.05
Assistant Professor female $ 92,000 $ 93,500 $ 95,750 4 0.04
Assistant Professor uncoded $ 96,000 $ 96,000 $ 97,000 3 0.03
Teaching Faculty female $ 45,000 $ 45,000 $ 45,000 1 0.01
Researcher male $ 56,871 $ 64,445 $ 73,657 34 0.34
Researcher female $ 56,324 $ 65,000 $ 70,232 15 0.15
Researcher uncoded $ 60,000 $ 60,000 $ 75,196 5 0.05


School of Geog Sci & Urban Pln

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Fotheringham, Stewart male Regents Professor $333,200
Turner, Billie female Regents Professor $221,647
Sailor, David male Professor $141,453
Cerveny, Randall male President’s Professor $132,462
Dorn, Ronald male Professor $124,288

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $115,722 $119,964 $130,418 10 0.22
Full Professor female $145,731 $171,036 $196,342 2 0.04
Associate Professor male $ 98,246 $101,605 $106,640 3 0.07
Associate Professor female $ 97,998 $101,527 $112,264 3 0.07
Associate Professor uncoded $102,156 $102,938 $103,720 2 0.04
Assistant Professor male $ 84,500 $ 85,308 $ 86,211 4 0.09
Assistant Professor female $ 85,526 $ 86,000 $ 87,750 3 0.07
Assistant Professor uncoded $ 85,000 $ 85,000 $ 85,000 1 0.02
Teaching Faculty male $ 55,000 $ 55,000 $ 57,752 3 0.07
Teaching Faculty female $ 60,547 $ 60,547 $ 60,547 1 0.02
Teaching Faculty uncoded $ 56,226 $ 56,226 $ 56,226 1 0.02
Researcher male $ 53,750 $ 57,577 $ 63,866 4 0.09
Researcher female $ 66,825 $ 73,068 $ 77,628 4 0.09
Researcher uncoded $ 50,000 $ 50,000 $ 71,136 5 0.11


School of Math & Stat Sciences

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Mahalov, Alex male Professor $224,020
McCulloch, Robert male Professor $212,170
Renaut, Rosemary female Professor $174,005
Gumel, Abba male Professor $167,945
Carlson, Marilyn female Professor $164,207

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $125,180 $136,726 $153,320 19 0.19
Full Professor female $144,838 $164,207 $169,106 3 0.03
Full Professor uncoded $132,695 $132,695 $132,695 1 0.01
Associate Professor male $ 96,670 $104,980 $110,148 15 0.15
Associate Professor female $ 93,844 $ 97,091 $ 98,876 4 0.04
Associate Professor uncoded $ 99,722 $104,744 $108,216 3 0.03
Assistant Professor male $ 92,781 $101,600 $105,000 5 0.05
Assistant Professor female $105,000 $105,000 $105,000 1 0.01
Assistant Professor uncoded $ 92,500 $ 95,000 $ 97,500 3 0.03
Teaching Faculty male $ 50,470 $ 59,955 $ 60,444 17 0.17
Teaching Faculty female $ 55,000 $ 57,390 $ 61,038 9 0.09
Teaching Faculty uncoded $ 55,000 $ 57,658 $ 65,626 8 0.08
Researcher male $ 53,250 $ 54,000 $ 55,114 7 0.07
Researcher female $ 66,882 $ 80,064 $ 93,245 2 0.02
Researcher uncoded $ 54,000 $ 54,000 $ 54,000 1 0.01


School of Molecular Sciences

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Navrotsky, Alexandra female Professor $358,209
Fromme, Petra female Regents Professor $226,197
Buttry, Daniel male Professor $192,925
Angell, Charles male Regents Professor $191,976
Moore, Thomas male Regents Professor $184,096

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $127,198 $144,175 $166,064 17 0.19
Full Professor female $142,128 $159,551 $226,197 5 0.05
Full Professor uncoded $134,869 $141,731 $155,156 3 0.03
Associate Professor male $103,056 $103,495 $105,099 5 0.05
Associate Professor female $101,409 $101,409 $101,409 1 0.01
Assistant Professor male $ 94,569 $ 95,524 $ 96,478 6 0.07
Assistant Professor female $ 93,000 $ 94,000 $ 94,856 3 0.03
Assistant Professor uncoded $ 96,478 $ 96,478 $ 96,478 1 0.01
Teaching Faculty male $ 46,430 $ 47,918 $ 48,700 6 0.07
Teaching Faculty female $ 48,164 $ 49,185 $ 67,268 11 0.12
Teaching Faculty uncoded $ 46,500 $ 47,999 $ 48,246 3 0.03
Researcher male $ 51,734 $ 61,885 $ 88,750 12 0.13
Researcher female $ 48,840 $ 61,000 $ 72,092 10 0.11
Researcher uncoded $ 47,599 $ 51,697 $ 59,388 8 0.09


School of Politics & Global St

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Hero, Rodney male Professor $341,750
Polt, Michael male Professor of Practice (FSC) $226,600
Bergen, Peter male Professor of Practice (FSC) $196,875
Thies, Cameron male Professor $175,000
Hechter, Michael male Professor $171,750

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $119,450 $171,750 $175,000 5 0.14
Full Professor female $131,875 $139,000 $146,125 2 0.05
Associate Professor male $100,500 $101,750 $102,000 5 0.14
Associate Professor female $ 91,052 $ 96,000 $ 99,772 6 0.16
Assistant Professor male $ 85,000 $ 86,750 $ 99,125 4 0.11
Assistant Professor female $ 88,750 $ 92,000 $ 95,250 2 0.05
Assistant Professor uncoded $ 85,000 $ 85,000 $ 85,000 1 0.03
Teaching Faculty male $ 56,500 $130,750 $172,031 8 0.22
Teaching Faculty female $ 56,625 $ 58,250 $ 81,875 3 0.08
Researcher female $ 60,000 $ 60,000 $ 60,000 1 0.03


School Of Public Affairs

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Bozeman, Barry male Regents Professor $236,900
Kapstein, Ethan male Professor $227,500
Reilly, Thomas male Professor $186,375
Corley, Elizabeth female Professor $150,070
Feeney, Mary female Professor $144,000

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $140,272 $186,375 $227,500 5 0.20
Full Professor female $145,518 $147,035 $148,552 2 0.08
Associate Professor male $102,820 $104,725 $113,488 4 0.16
Associate Professor uncoded $106,496 $106,496 $106,496 1 0.04
Assistant Professor male $ 92,150 $ 94,200 $ 94,600 3 0.12
Assistant Professor female $ 90,125 $ 92,250 $ 94,375 2 0.08
Assistant Professor uncoded $ 88,500 $ 88,500 $ 88,500 1 0.04
Teaching Faculty male $ 49,900 $ 55,800 $ 61,700 4 0.16
Teaching Faculty female $ 55,890 $ 62,780 $ 68,890 3 0.12


School of Social Transform

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Brayboy, Bryan male President’s Professor $219,429
Scott, Kimberly female Professor $180,000
Lomawaima, K uncoded Professor $161,685
Swadener, Elizabeth female Professor $151,478
Moore, Elsie female Professor $148,250

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $154,309 $176,016 $197,722 2 0.04
Full Professor female $109,804 $118,089 $149,057 8 0.16
Full Professor uncoded $161,685 $161,685 $161,685 1 0.02
Associate Professor male $ 88,801 $ 92,890 $100,738 9 0.18
Associate Professor female $ 85,140 $ 94,392 $ 99,673 14 0.27
Associate Professor uncoded $100,673 $100,673 $100,673 1 0.02
Assistant Professor male $ 58,750 $ 67,500 $ 76,250 2 0.04
Assistant Professor female $ 85,000 $ 85,000 $ 85,000 5 0.10
Assistant Professor uncoded $ 85,000 $ 85,000 $ 85,000 1 0.02
Teaching Faculty male $ 53,460 $ 54,171 $ 54,882 2 0.04
Teaching Faculty female $ 52,422 $ 59,844 $ 63,997 3 0.06
Teaching Faculty uncoded $ 45,000 $ 45,000 $ 45,000 1 0.02
Researcher female $ 70,343 $ 70,343 $ 70,343 1 0.02
Researcher uncoded $ 42,500 $ 42,500 $ 42,500 1 0.02


School Of Social Work

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Messing, Jill female Professor $160,000
Shafer, Michael male Professor $137,401
Ashford, Jose male Professor $131,845
Segal, Elizabeth female Professor $130,390
Lecroy, Craig male Professor $129,970

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $127,502 $130,908 $133,234 4 0.06
Full Professor female $123,725 $130,390 $145,195 3 0.05
Associate Professor male $ 91,649 $ 92,864 $ 94,078 2 0.03
Associate Professor female $ 90,194 $ 90,267 $ 91,528 5 0.08
Assistant Professor male $ 82,250 $ 83,500 $ 84,750 2 0.03
Assistant Professor female $ 83,000 $ 83,550 $ 83,750 10 0.16
Assistant Professor uncoded $ 82,425 $ 83,000 $ 84,700 4 0.06
Teaching Faculty male $ 35,725 $ 48,450 $ 49,800 3 0.05
Teaching Faculty female $ 48,512 $ 51,700 $ 53,728 26 0.41
Researcher male $ 60,000 $ 60,000 $ 60,000 1 0.02
Researcher female $ 56,520 $ 64,000 $ 66,250 4 0.06


SHPRS History Faculty

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Fixico, Donald male Regents Professor $271,527
Austin, Curtis male Assoc Professor $190,000
Alexander, Leslie female Assoc Professor $190,000
Saikia, Yasmin female Professor $181,750
Critchlow, Donald male Professor $158,446

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $101,565 $130,000 $158,446 5 0.12
Full Professor female $130,808 $147,789 $164,770 2 0.05
Full Professor uncoded $135,206 $135,206 $135,206 1 0.02
Associate Professor male $108,000 $108,707 $122,268 5 0.12
Associate Professor female $ 75,612 $ 91,369 $104,841 7 0.17
Assistant Professor male $ 75,741 $ 76,732 $ 78,241 3 0.07
Assistant Professor female $ 77,506 $ 79,750 $ 79,875 3 0.07
Assistant Professor uncoded $ 82,494 $ 82,494 $ 82,494 1 0.02
Teaching Faculty male $ 50,575 $ 51,000 $ 67,667 9 0.21
Teaching Faculty female $ 49,429 $ 58,334 $ 67,959 4 0.10
Teaching Faculty uncoded $ 47,992 $ 47,992 $ 47,992 1 0.02
Researcher female $ 60,000 $ 60,000 $ 60,000 1 0.02


Social & Behavioral Sciences

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Nanez, Jose male President’s Professor $151,212
Mickelson, Kristin female Professor $125,464
Kassing, Jeffrey male Professor $118,412
Kirby, Andrew male Professor $117,816
Nadesan, Majia uncoded Professor $114,104

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $105,796 $113,000 $118,263 6 0.09
Full Professor female $125,464 $125,464 $125,464 1 0.01
Full Professor uncoded $114,104 $114,104 $114,104 1 0.01
Associate Professor male $ 93,394 $ 97,660 $ 99,152 5 0.07
Associate Professor female $ 91,490 $ 93,801 $ 98,000 9 0.13
Assistant Professor male $ 83,562 $ 85,625 $ 87,438 4 0.06
Assistant Professor female $ 81,000 $ 82,987 $ 85,000 8 0.12
Assistant Professor uncoded $ 82,500 $ 82,500 $ 82,500 1 0.01
Teaching Faculty male $ 54,000 $ 54,000 $ 54,040 9 0.13
Teaching Faculty female $ 52,000 $ 54,000 $ 55,000 19 0.28
Teaching Faculty uncoded $ 54,000 $ 54,000 $ 54,000 1 0.01
Researcher female $ 48,750 $ 52,810 $ 56,715 4 0.06


Sols Administration & Faculty

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Sala, Osvaldo male Regents Professor $291,567
Grimm, Nancy female Regents Professor $253,500
Compton, Carolyn female Professor $241,600
Jacobs, Bertram male Professor $202,800
Perrings, Charles male Professor $188,538

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $119,282 $131,002 $158,089 21 0.18
Full Professor female $123,004 $146,298 $158,500 11 0.09
Full Professor uncoded $150,920 $154,230 $157,540 2 0.02
Associate Professor male $ 98,827 $105,545 $123,339 10 0.09
Associate Professor female $102,720 $110,150 $118,748 4 0.03
Associate Professor uncoded $ 99,294 $102,819 $106,344 2 0.02
Assistant Professor male $ 90,550 $ 93,700 $ 96,850 2 0.02
Assistant Professor female $ 92,000 $ 94,000 $ 94,150 7 0.06
Assistant Professor uncoded $ 99,000 $ 99,000 $ 99,000 1 0.01
Teaching Faculty male $ 48,000 $ 48,750 $ 67,360 7 0.06
Teaching Faculty female $ 48,000 $ 48,000 $ 53,150 8 0.07
Researcher male $ 50,123 $ 52,000 $ 58,260 17 0.15
Researcher female $ 49,500 $ 51,638 $ 65,241 16 0.14
Researcher uncoded $ 47,494 $ 50,678 $ 55,414 8 0.07


SOS Faculty & Researchers

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Pfirman, Stephanie female Professor $255,000
Melnick, Robert male Research Scientist $249,765
Basile, George male Professor of Practice (FSC) $168,913
Childers, Daniel male Professor $145,466
Aggarwal, Rimjhim uncoded Assoc Professor $143,500

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $118,923 $132,258 $139,604 4 0.08
Full Professor female $123,124 $126,249 $190,624 3 0.06
Full Professor uncoded $118,827 $118,827 $118,827 1 0.02
Associate Professor male $ 97,101 $ 97,515 $ 97,929 2 0.04
Associate Professor female $ 98,982 $ 99,813 $100,644 2 0.04
Associate Professor uncoded $143,500 $143,500 $143,500 1 0.02
Assistant Professor male $ 86,307 $ 91,898 $101,164 4 0.08
Assistant Professor female $ 87,116 $ 87,125 $102,562 3 0.06
Assistant Professor uncoded $ 87,333 $ 87,966 $ 88,600 2 0.04
Teaching Faculty male $ 50,000 $ 52,292 $ 78,590 10 0.20
Teaching Faculty female $ 45,000 $ 45,000 $ 45,900 11 0.22
Teaching Faculty uncoded $ 45,000 $ 50,000 $ 52,632 5 0.10
Researcher male $103,691 $152,382 $201,074 2 0.04


The Design School

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Jackson, Maria female Professor $142,011
Underhill, Michael male Professor $135,995
Brooks, Kenneth male Professor $133,800
Petrucci, Darren male Professor $132,762
Rotondi, Michael male Professor $129,528

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $119,217 $129,528 $133,281 7 0.14
Full Professor female $142,011 $142,011 $142,011 1 0.02
Full Professor uncoded $128,056 $128,056 $128,056 1 0.02
Associate Professor male $ 80,020 $ 81,763 $ 83,445 9 0.18
Associate Professor female $ 80,173 $ 91,695 $103,351 5 0.10
Associate Professor uncoded $ 82,032 $ 82,032 $ 82,032 1 0.02
Assistant Professor male $ 70,250 $ 70,500 $ 70,750 3 0.06
Assistant Professor female $ 70,700 $ 70,700 $ 70,700 1 0.02
Assistant Professor uncoded $ 70,500 $ 71,000 $ 71,375 3 0.06
Teaching Faculty male $ 48,300 $ 55,547 $ 61,722 8 0.16
Teaching Faculty female $ 50,450 $ 54,974 $ 66,225 10 0.20


The Sanford School

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Elliott, Stephen male Professor $281,860
Sandefur, Rebecca female Professor $220,000
Fabes, Richard male Professor $190,000
Meek, Shantel female Professor of Practice (FSC) $175,097
Ladd, Gary male Professor $165,726

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $124,358 $158,364 $183,932 6 0.13
Full Professor female $122,326 $127,953 $132,502 7 0.15
Associate Professor male $ 98,500 $ 98,500 $ 98,500 1 0.02
Associate Professor female $ 99,132 $100,255 $116,712 8 0.17
Assistant Professor male $ 86,212 $ 86,775 $ 87,338 2 0.04
Assistant Professor female $ 85,529 $ 87,358 $ 88,800 6 0.13
Teaching Faculty male $ 49,628 $ 49,628 $ 49,628 1 0.02
Teaching Faculty female $ 82,609 $ 82,609 $ 88,433 5 0.11
Teaching Faculty uncoded $ 49,300 $ 49,300 $ 49,300 1 0.02
Researcher male $113,603 $113,603 $113,603 1 0.02
Researcher female $ 52,500 $ 52,500 $ 59,282 7 0.15
Researcher uncoded $ 53,375 $ 54,250 $ 55,125 2 0.04


WPC Accountancy

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Lamoreaux, Phillip male Assoc Professor $323,113
Li, Yinghua uncoded Professor $322,573
Matejka, Michal female Professor $309,350
Reckers, Philip male Professor $300,975
Kaplan, Steven male Professor $297,109

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $248,620 $297,109 $299,042 3 0.08
Full Professor female $309,350 $309,350 $309,350 1 0.03
Full Professor uncoded $268,143 $286,286 $304,430 2 0.05
Associate Professor male $224,344 $262,454 $280,428 4 0.10
Associate Professor female $267,244 $274,394 $278,578 4 0.10
Associate Professor uncoded $265,220 $265,220 $265,220 1 0.03
Assistant Professor male $217,494 $219,475 $221,306 6 0.15
Assistant Professor female $215,475 $215,475 $215,475 1 0.03
Assistant Professor uncoded $225,000 $225,000 $225,000 1 0.03
Teaching Faculty male $ 91,703 $106,295 $129,500 8 0.21
Teaching Faculty female $ 96,612 $120,650 $143,750 8 0.21


WPC Economics

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Prescott, Edward male Regents Professor $436,101
Manelli, Alejandro male Professor $320,449
Silverman, Daniel male Professor $310,840
Chade, Hector male Professor $302,410
Mehra, Rajnish uncoded Professor $296,743

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $191,220 $257,474 $302,410 13 0.30
Full Professor female $180,091 $180,091 $180,091 1 0.02
Full Professor uncoded $296,743 $296,743 $296,743 1 0.02
Associate Professor male $172,974 $183,753 $184,974 6 0.14
Associate Professor female $149,103 $153,830 $158,558 2 0.05
Associate Professor uncoded $107,984 $107,984 $107,984 1 0.02
Assistant Professor male $147,288 $154,000 $157,750 4 0.09
Assistant Professor female $147,433 $152,288 $157,144 2 0.05
Teaching Faculty male $ 99,436 $101,873 $104,520 8 0.19
Teaching Faculty female $102,700 $104,300 $105,800 4 0.09
Researcher male $111,706 $111,706 $111,706 1 0.02


WPC Information Systems

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Chen, Pei-yu uncoded Professor $230,917
Zhang, Zhongju uncoded Professor $224,029
Shao, Benjamin male Professor $209,807
Shi, Zhan uncoded Assoc Professor $200,867
Han, Sang Pil male Assoc Professor $195,019

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $130,719 $157,082 $183,444 2 0.06
Full Professor uncoded $225,751 $227,473 $229,195 2 0.06
Associate Professor male $177,755 $183,510 $189,264 2 0.06
Associate Professor uncoded $178,106 $185,693 $193,280 2 0.06
Assistant Professor male $168,039 $168,039 $168,039 1 0.03
Assistant Professor female $168,151 $172,100 $176,050 2 0.06
Assistant Professor uncoded $180,000 $180,000 $180,000 1 0.03
Teaching Faculty male $ 90,000 $ 95,000 $120,000 13 0.36
Teaching Faculty female $ 75,056 $ 93,905 $124,146 4 0.11
Teaching Faculty uncoded $ 86,008 $100,000 $103,666 7 0.19


WPC Management

TOP FIVE SALARIES

Full.Name gender Job.Description salary
LePine, Jeffery male Professor $402,257
Gomez-Mejia, Luis male Regents Professor $361,393
Ashforth, Blake male Regents Professor $338,580
Corley, Kevin male Professor $282,000
Semadeni, Matthew male Professor $273,267

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $219,152 $282,000 $349,986 7 0.17
Associate Professor male $195,430 $228,780 $232,799 8 0.20
Associate Professor female $144,591 $155,322 $168,114 4 0.10
Assistant Professor female $215,000 $215,000 $215,000 1 0.02
Assistant Professor uncoded $163,151 $163,151 $163,151 1 0.02
Teaching Faculty male $ 88,018 $101,578 $120,390 13 0.32
Teaching Faculty female $102,000 $103,807 $106,524 5 0.12
Teaching Faculty uncoded $122,520 $122,520 $122,520 1 0.02
Researcher male $ 47,208 $ 47,208 $ 47,208 1 0.02


WPC Supply Chain Management

TOP FIVE SALARIES

Full.Name gender Job.Description salary
Choi, Thomas male Professor $288,818
Carter, Craig male Professor $263,000
Fowler, John male Professor $256,139
Rabinovich, Elliot male Professor $252,685
Li, Hongmin uncoded Professor $250,000

PAY RANGE BY RANK AND GENDER

title gender q25 q50 q75 n p
Full Professor male $217,774 $244,224 $256,139 9 0.30
Full Professor uncoded $250,000 $250,000 $250,000 1 0.03
Associate Professor male $183,522 $185,682 $187,841 2 0.07
Associate Professor uncoded $167,055 $178,720 $180,270 3 0.10
Assistant Professor male $154,050 $160,000 $165,000 3 0.10
Assistant Professor female $148,601 $148,601 $148,601 1 0.03
Teaching Faculty male $ 96,756 $113,500 $119,490 7 0.23
Teaching Faculty female $ 89,478 $ 90,457 $ 91,436 2 0.07
Teaching Faculty uncoded $103,104 $106,207 $109,310 2 0.07







ds4ps

Data Science for
Public Service